DELETE from localetype;
go
INSERT INTO localetype
            (acronym, name          , Description) 
    VALUES  ('ctt'  , 'Continent'   , 'A continent is one of several large landmasses on Earth')
GO
INSERT INTO localetype
            (acronym, name              , Description) 
    VALUES  ('sct'  , 'SubContinent'    , 'A subcontinent is a large, relatively self-contained landmass forming a subdivision of a continent.')
GO
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('ctr'  , 'Country' , 'Country')
GO
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('cty', 'County'     , 'A county is a land area of local government within a larger state. A county may have cities and towns within its area')
go
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('cnd', 'Cound'     ,'')
GO
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('cty', 'City'     ,'')
GO 
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('vlg', 'village'     ,'')
GO
INSERT INTO localetype
            (acronym, name      , Description) 
    VALUES  ('twn', 'Town'     , '')
go


